﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MNL_Convert.aspx.cs" Inherits="StreetSmartAdmin.MNL_Convert"  EnableEventValidation = "false"%>


<%@ Register TagPrefix="CustUserCtrl" TagName="Header" Src="MNLheader.ascx" %>
<%@ Register TagPrefix="CustUserCtrl" TagName="Footer" Src="Footer.ascx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<script language="javascript" type="text/javascript" src="WdatePicker.js"></script>
<head id="Head1" runat="server">
    <title>Street Smart Energy Admin</title>
    <link type="text/css" rel="stylesheet" href="style.css" />
</head>
<body>
    <form id="form2" runat="server">
    <CustUserCtrl:Header ID="Header" runat="server"></CustUserCtrl:Header>
    <h3>
    <!--
    <asp:Label ID="Label1" runat="server" Text="Conversions Date"></asp:Label>
    <br/>
    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Export" />
    -->
     <asp:TextBox ID="TextBox1" runat="server" onclick="WdatePicker()" visible="false"></asp:TextBox>
    <br />
    <br />
    <asp:Label ID="Label2" runat="server" Text="Conversions Date Range"></asp:Label>   
    <br />
    <asp:Label ID="Label3" runat="server" Text="From"></asp:Label>
    <asp:TextBox ID="TextBox2" runat="server" onclick="WdatePicker()" ></asp:TextBox>
    <asp:Label ID="Label4" runat="server" Text="To"></asp:Label>
    <asp:TextBox ID="TextBox3" runat="server" onclick="WdatePicker()" ></asp:TextBox>
        <asp:Button ID="Button3" runat="server" onclick="Button3_Click" Text="Search" />
    <!--<asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="Export" />-->
        <asp:Button ID="Button4" runat="server" onclick="Button4_Click" Text="Export"/>
    </h3>   
    <CustUserCtrl:Footer id="Footer" runat="server"></CustUserCtrl:Footer> 
    <asp:Label ID="Label5" runat="server" Text="Page Size :"></asp:Label>

    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true" 
        onselectedindexchanged="DropDownList1_SelectedIndexChanged">
        <asp:ListItem Value="10">10</asp:ListItem>                                   
        <asp:ListItem Value="20">20</asp:ListItem>
        <asp:ListItem Value="50">50</asp:ListItem>
        <asp:ListItem Value="100">100</asp:ListItem>
        <asp:ListItem Value="200">200</asp:ListItem>
        <asp:ListItem Value="500">500</asp:ListItem>
        <asp:ListItem Value="1000">1000</asp:ListItem>
    </asp:DropDownList>

    <asp:GridView ID="GridView1" runat="server" CssClass="mGrid"
            PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" 
            DataSourceID="SqlDataSource1" AutoGenerateColumns="False" 
            AllowPaging="True" DataKeyNames="userID"
            onselectedindexchanged="GridView1_SelectedIndexChanged" 
            EnableModelValidation="True">
<AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>
        <Columns>
            <asp:CommandField ShowSelectButton="True" />
            <asp:BoundField DataField="Date Converted" HeaderText="Date Converted" 
                SortExpression="Date Converted" />
            <asp:BoundField DataField="Operator SSE" HeaderText="Operator SSE" 
                SortExpression="Operator SSE" />
            <asp:BoundField DataField="Source Code" HeaderText="Source Code" 
                SortExpression="Source Code" />
            <asp:BoundField DataField="Vendor ID" HeaderText="Vendor ID" 
                SortExpression="Vendor ID" />
            <asp:BoundField DataField="RESI/SME" HeaderText="RESI/SME" 
                SortExpression="RESI/SME" />
            <asp:BoundField DataField="Electricity Conversion?" 
                HeaderText="Electricity Conversion?" SortExpression="Electricity Conversion?" />
            <asp:BoundField DataField="Gas Conversion?" HeaderText="Gas Conversion?" 
                SortExpression="Gas Conversion?" />
            <asp:BoundField DataField="Annual Electricity Spend" 
                HeaderText="Annual Electricity Spend" 
                SortExpression="Annual Electricity Spend" />
            <asp:BoundField DataField="Annual Gas Spend" HeaderText="Annual Gas Spend" 
                SortExpression="Annual Gas Spend" />
            <asp:BoundField DataField="Mover/Swicher" HeaderText="Mover/Swicher" 
                SortExpression="Mover/Swicher" />
            <asp:BoundField DataField="Move In Date" HeaderText="Move In Date" 
                SortExpression="Move In Date" />
            <asp:BoundField DataField="Company Name" HeaderText="Company Name" 
                SortExpression="Company Name" />
            <asp:BoundField DataField="Company ABN" HeaderText="Company ABN" 
                SortExpression="Company ABN" />
            <asp:BoundField DataField="First Account Holder Title" 
                HeaderText="First Account Holder Title" 
                SortExpression="First Account Holder Title" />
            <asp:BoundField DataField="First Account Holder First Name" 
                HeaderText="First Account Holder First Name" 
                SortExpression="First Account Holder First Name" />
            <asp:BoundField DataField="First Account Holder Surname" 
                HeaderText="First Account Holder Surname" 
                SortExpression="First Account Holder Surname" />
            <asp:BoundField DataField="First Account Holder DOB" 
                HeaderText="First Account Holder DOB" 
                SortExpression="First Account Holder DOB" />
            <asp:BoundField DataField="ID Number" HeaderText="ID Number" 
                SortExpression="ID Number" />
            <asp:BoundField DataField="ID Expiry" HeaderText="ID Expiry" 
                SortExpression="ID Expiry" />
            <asp:BoundField DataField="ID Type" HeaderText="ID Type" 
                SortExpression="ID Type" />
            <asp:BoundField DataField="Second Account Holder Title" 
                HeaderText="Second Account Holder Title" 
                SortExpression="Second Account Holder Title" />
            <asp:BoundField DataField="Second Account Holder First Name" 
                HeaderText="Second Account Holder First Name" 
                SortExpression="Second Account Holder First Name" />
            <asp:BoundField DataField="Second Account Holder Surname" 
                HeaderText="Second Account Holder Surname" 
                SortExpression="Second Account Holder Surname" />
            <asp:BoundField DataField="Second Account Holder DOB" 
                HeaderText="Second Account Holder DOB" 
                SortExpression="Second Account Holder DOB" />
            <asp:BoundField DataField="Contact Tel" HeaderText="Contact Tel" 
                SortExpression="Contact Tel" />
            <asp:BoundField DataField="Second Tel" HeaderText="Second Tel" 
                SortExpression="Second Tel" />
            <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
            <asp:BoundField DataField="Supply Address" HeaderText="Supply Address" 
                SortExpression="Supply Address" />
            <asp:BoundField DataField="Supply Address Suburb" 
                HeaderText="Supply Address Suburb" SortExpression="Supply Address Suburb" />
            <asp:BoundField DataField="Supply Address State" 
                HeaderText="Supply Address State" SortExpression="Supply Address State" />
            <asp:BoundField DataField="Supply Address Postcode" 
                HeaderText="Supply Address Postcode" SortExpression="Supply Address Postcode" />
            <asp:BoundField DataField="Tenant/Owner" HeaderText="Tenant/Owner" 
                SortExpression="Tenant/Owner" />
            <asp:BoundField DataField="Elec" HeaderText="Elec" SortExpression="Elec" />
            <asp:BoundField DataField="Gas" HeaderText="Gas" SortExpression="Gas" />
            <asp:BoundField DataField="Product Type" HeaderText="Product Type" 
                SortExpression="Product Type" />
            <asp:BoundField DataField="No Of People In House" 
                HeaderText="No Of People In House" SortExpression="No Of People In House" />
            <asp:BoundField DataField="Concession Card Type" 
                HeaderText="Concession Card Type" SortExpression="Concession Card Type" />
            <asp:BoundField DataField="Concession Card Entitlement" 
                HeaderText="Concession Card Entitlement" 
                SortExpression="Concession Card Entitlement" />
            <asp:BoundField DataField="Concession Card No" HeaderText="Concession Card No" 
                SortExpression="Concession Card No" />
            <asp:BoundField DataField="Concession Card Exp" 
                HeaderText="Concession Card Exp" SortExpression="Concession Card Exp" />
            <asp:BoundField DataField="Name On Concession Card" 
                HeaderText="Name On Concession Card" SortExpression="Name On Concession Card" />
            <asp:BoundField DataField="NMI" HeaderText="NMI" SortExpression="NMI" />
            <asp:BoundField DataField="MIRN" HeaderText="MIRN" SortExpression="MIRN" />
            <asp:BoundField DataField="Any Hazards?" HeaderText="Any Hazards?" 
                SortExpression="Any Hazards?" />
            <asp:BoundField DataField="Any Access Requirements?" 
                HeaderText="Any Access Requirements?" 
                SortExpression="Any Access Requirements?" />
            <asp:BoundField DataField="Special Instructions For Access?" 
                HeaderText="Special Instructions For Access?" 
                SortExpression="Special Instructions For Access?" />
            <asp:BoundField DataField="Advised Main Switch Needs Turning Off?" 
                HeaderText="Advised Main Switch Needs Turning Off?" 
                SortExpression="Advised Main Switch Needs Turning Off?" />
            <asp:BoundField DataField="Safety Certificate Required?" 
                HeaderText="Safety Certificate Required?" 
                SortExpression="Safety Certificate Required?" />
            <asp:BoundField DataField="Elec Status" HeaderText="Elec Status" 
                SortExpression="Elec Status" />
            <asp:BoundField DataField="Gas Status" HeaderText="Gas Status" 
                SortExpression="Gas Status" />
            <asp:BoundField DataField="Reason" HeaderText="Reason" 
                SortExpression="Reason" />
            <asp:BoundField DataField="TRUenergy Comments" HeaderText="TRUenergy Comments" 
                SortExpression="TRUenergy Comments" />
            <asp:BoundField DataField="Existing TRUEnergy Customer?" 
                HeaderText="Existing TRUEnergy Customer?" 
                SortExpression="Existing TRUEnergy Customer?" />  
            <asp:BoundField DataField="SSE Operator Feedback" 
                HeaderText="SSE Operator Feedback" SortExpression="SSE Operator Feedback" />
            
        </Columns>

<PagerStyle CssClass="pgr"></PagerStyle>
    </asp:GridView>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"       
        
        SelectCommand="select UserID, DateConverted as 'Date Converted', OperatorSSE as 'Operator SSE', SourceCode as 'Source Code', VendorID as 'Vendor ID', RESI_SME as 'RESI/SME', ElectricityConversion as 'Electricity Conversion?', GasConversion as 'Gas Conversion?', ElecTotalAnnualSpend as 'Annual Electricity Spend', GasTotalAnnualSpend as 'Annual Gas Spend', MoverSwicher as 'Mover/Swicher', MoveInDate as 'Move In Date', CompanyName as 'Company Name', CompanyABN as 'Company ABN', FirstAccountHolderTitle as 'First Account Holder Title',  FirstAccountHolderFirstName as 'First Account Holder First Name', FirstAccountHolderSurname as 'First Account Holder Surname', FirstAccountHolderDOB as 'First Account Holder DOB', ID_Number as 'ID Number', ID_Expiry as 'ID Expiry', ID_Type as 'ID Type', SecondAccountHolderTitle as 'Second Account Holder Title', SecondAccountHolderFirstName as 'Second Account Holder First Name', SecondAccountHolderSurname as 'Second Account Holder Surname', SecondAccountHolderDOB as 'Second Account Holder DOB', Phone as 'Contact Tel', Mobile as 'Second Tel', Email, SupplyAddress as 'Supply Address', SupplyAddressSuburb as 'Supply Address Suburb', SupplyAddressState as 'Supply Address State', SupplyAddressPostcode as 'Supply Address Postcode', TenantOwner as 'Tenant/Owner', Elec, Gas, ProductType as 'Product Type', NoOfPeopleInHouse as 'No Of People In House', ConcessionCardType as 'Concession Card Type', ConcessionCardEntitlement as 'Concession Card Entitlement', ConcessionCardNo as 'Concession Card No', ConcessionCardExp as 'Concession Card Exp', NameOnConcessionCard as 'Name On Concession Card', NMI, MIRN, AnyHazards as 'Any Hazards?', AnyAccessRequirements as 'Any Access Requirements?', SpecialInstructionsForAccess as 'Special Instructions For Access?', AdvisedMainSwitchNeedsTurningOff as 'Advised Main Switch Needs Turning Off?', SafetyCertificateRequired as 'Safety Certificate Required?', ElecStatus as 'Elec Status', GasStatus as 'Gas Status', Reason, TRUenergyComments as 'TRUenergy Comments', ExistingTRUEnergyCustomer as 'Existing TRUEnergy Customer?', SSE_Operator_Feedback as 'SSE Operator Feedback', SSE_Operator_Feedback as 'SSE Operator Feedback' from tblUser where DateConverted=@Value and [PromotionCode] = 'MANILA' order by DateConverted;">
        <SelectParameters>
                    <asp:ControlParameter ControlID="TextBox1" Name="Value" Type="String" PropertyName="Text" /> 
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"        
        
        SelectCommand="select USerID, DateConverted as 'Date Converted', OperatorSSE as 'Operator SSE', SourceCode as 'Source Code', VendorID as 'Vendor ID', RESI_SME as 'RESI/SME', ElectricityConversion as 'Electricity Conversion?', GasConversion as 'Gas Conversion?', ElecTotalAnnualSpend as 'Annual Electricity Spend', GasTotalAnnualSpend as 'Annual Gas Spend', MoverSwicher as 'Mover/Swicher', MoveInDate as 'Move In Date', CompanyName as 'Company Name', CompanyABN as 'Company ABN', FirstAccountHolderTitle as 'First Account Holder Title',  FirstAccountHolderFirstName as 'First Account Holder First Name', FirstAccountHolderSurname as 'First Account Holder Surname', FirstAccountHolderDOB as 'First Account Holder DOB', ID_Number as 'ID Number', ID_Expiry as 'ID Expiry', ID_Type as 'ID Type', SecondAccountHolderTitle as 'Second Account Holder Title', SecondAccountHolderFirstName as 'Second Account Holder First Name', SecondAccountHolderSurname as 'Second Account Holder Surname', SecondAccountHolderDOB as 'Second Account Holder DOB', Phone as 'Contact Tel', Mobile as 'Second Tel', Email, SupplyAddress as 'Supply Address', SupplyAddressSuburb as 'Supply Address Suburb', SupplyAddressState as 'Supply Address State', SupplyAddressPostcode as 'Supply Address Postcode', TenantOwner as 'Tenant/Owner', Elec, Gas, ProductType as 'Product Type', NoOfPeopleInHouse as 'No Of People In House', ConcessionCardType as 'Concession Card Type', ConcessionCardEntitlement as 'Concession Card Entitlement', ConcessionCardNo as 'Concession Card No', ConcessionCardExp as 'Concession Card Exp', NameOnConcessionCard as 'Name On Concession Card', NMI, MIRN, AnyHazards as 'Any Hazards?', AnyAccessRequirements as 'Any Access Requirements?', SpecialInstructionsForAccess as 'Special Instructions For Access?', AdvisedMainSwitchNeedsTurningOff as 'Advised Main Switch Needs Turning Off?', SafetyCertificateRequired as 'Safety Certificate Required?', ElecStatus as 'Elec Status', GasStatus as 'Gas Status', Reason, TRUenergyComments as 'TRUenergy Comments', ExistingTRUEnergyCustomer as 'Existing TRUEnergy Customer?', SSE_Operator_Feedback as 'SSE Operator Feedback' from tblUser where DateConverted >= @Value1 and DateConverted <= @Value2 and [PromotionCode] = 'MANILA' order by DateConverted;">
        <SelectParameters>
                    <asp:ControlParameter ControlID="TextBox2" Name="Value1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="TextBox3" Name="Value2" Type="String" PropertyName="Text" /> 
        </SelectParameters>
    </asp:SqlDataSource>

<asp:DetailsView ID="DetailsView1" runat="Server" CellPadding="4" ForeColor="#333333"
                        GridLines="None" DataSourceID="SqlDataSource3" AllowPaging="True" AutoGenerateRows="False"
                        DataKeyNames="userID" AutoGenerateInsertButton="True" DefaultMode="Edit" CssClass="mGrid"
                        PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" EnableModelValidation="True">
                        <AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>
                        <Fields>

                            <asp:TemplateField HeaderText="General Details" HeaderStyle-Font-Size="Large" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="userID" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>                           
                                    <asp:Label ID="lbluserID" runat="server" Text='<%# Eval("userID") %>' />
                                </ItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Registration Date" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>   
                                    <asp:Label ID="lblInsertDate" runat="server" Text='<%# Eval("InsertDate")%>' />
                                </ItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Date Converted *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblDateConverted" runat="server" Text='<%# bind("DateConverted")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="DateConverted" runat="server" Text='<%# Bind("DateConverted") %>' onclick="WdatePicker({minDate:'%y-%M-#{%d}'})" ></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Account Status" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblAccountStatus" runat="server" Text='<%# bind("AccountStatus")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="AccountStatus" width="18px" readonly="true" runat="server" Text='<%# Bind("AccountStatus") %>'></asp:TextBox>
                                    <asp:TextBox ID="StatusName" runat="server" Text='<%# Bind("StatusName") %>'></asp:TextBox>
                                    <asp:DropDownList name="selAccountStatus" ID="selAccountStatus" runat="Server" DataSourceID="SqlDataSource6"
                                        DataTextField="AccountStatusName" DataValueField="AccountStatusID" SelectedValue='<%# Bind("AccountStatus") %>'
                                        onchange="AccountStatusChanged()">
                                    </asp:DropDownList><br />
                                    <asp:TextBox ID="AccountStatusHistory" Rows="5" cols="40" Width="60%" runat="server"
                                        TextMode="MultiLine" Text='<%# Bind("AccountStatusHistory") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Preferred Day To Contact" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblPreferredDay" runat="server" Text='<%# bind("PreferredDay")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="PreferredDay" runat="server" onclick="WdatePicker()" Text='<%# Bind("PreferredDay") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Preferred Time To Contact" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="PreferredTime" runat="server" Text='<%# Bind("PreferredTime") %>'></asp:TextBox>                                   
                                    <asp:DropDownList name="selPreferredTime" ID="selPreferredTime" runat="Server" HeaderText="Preferred Time" onchange="PreferredTimeChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="8:00 AM - 9:00 AM">8:00 AM - 9:00 AM</asp:ListItem>
                                        <asp:ListItem Value="9:00 AM - 10:00 AM">9:00 AM - 10:00 AM</asp:ListItem>
                                        <asp:ListItem Value="10:00 AM - 11:00 AM">10:00 AM - 11:00 AM</asp:ListItem>
                                        <asp:ListItem Value="11:00 AM - 12:00 AM">11:00 AM - 12:00 AM</asp:ListItem>
                                        <asp:ListItem Value="12:00 AM - 1:00 PM">12:00 AM - 1:00 PM</asp:ListItem>
                                        <asp:ListItem Value="1:00 PM - 2:00 PM">1:00 PM - 2:00 PM</asp:ListItem>
                                        <asp:ListItem Value="2:00 PM - 3:00 PM">2:00 PM - 3:00 PM</asp:ListItem>
                                        <asp:ListItem Value="3:00 PM - 4:00 PM">3:00 PM - 4:00 PM</asp:ListItem>
                                        <asp:ListItem Value="4:00 PM - 5:00 PM">4:00 PM - 5:00 PM</asp:ListItem>
                                        <asp:ListItem Value="5:00 PM - 6:00 PM">5:00 PM - 6:00 PM</asp:ListItem>
                                        <asp:ListItem Value="6:00 PM - 7:00 PM">6:00 PM - 7:00 PM</asp:ListItem>
                                        <asp:ListItem Value="7:00 PM - 8:00 PM">7:00 PM - 8:00 PM</asp:ListItem>
                                        <asp:ListItem Value="8:00 PM - 9:00 PM">8:00 PM - 9:00 PM</asp:ListItem>
                                    </asp:DropDownList> 
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="SSE Operator *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="OperatorSSE" runat="server" Text='<%# Bind("OperatorSSE") %>'></asp:TextBox>
                                    <asp:DropDownList name="selOperatorSSE" ID="selOperatorSSE" runat="Server" HeaderText="Operator SSE" onchange="OperatorSSEChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Chuck Robinson">Chuck Robinson</asp:ListItem>     
                                        <asp:ListItem Value="Edia Fisher">Edia Fisher</asp:ListItem>
                                        <asp:ListItem Value="Kelvin Wiggins">Kelvin Wiggins</asp:ListItem>
                                        <asp:ListItem Value="Omar Sabbagh">Omar Sabbagh</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Promotion Code" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblPromotionCode" runat="server" Text='<%# bind("PromotionCode")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="PromotionCode" runat="server" Text='<%# Bind("PromotionCode") %>' visible="true"></asp:TextBox>
                                    <asp:DropDownList name="selPromotionCode" ID="selPromotionCode" runat="Server"
                                        onchange="PromotionCodeChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem>DIRECT CUSTOMER</asp:ListItem>
                                        <asp:ListItem>2GB</asp:ListItem>
                                        <asp:ListItem>BALGOWLAH</asp:ListItem>
                                        <asp:ListItem>CAMPAIGN 1</asp:ListItem>
                                        <asp:ListItem>CAMPAIGN 2</asp:ListItem>
                                        <asp:ListItem>CAMPAIGN 3</asp:ListItem>
                                        <asp:ListItem>CHATSWOOD</asp:ListItem>
                                        <asp:ListItem>CHILD CARE VIC</asp:ListItem>
                                        <asp:ListItem>CO-OP BOOKSHOP</asp:ListItem>
                                        <asp:ListItem>CRICKET NSW</asp:ListItem>
                                        <asp:ListItem>CRICKET NSW Clubs</asp:ListItem>
                                        <asp:ListItem>ERSKINEVILLE</asp:ListItem>
                                        <asp:ListItem>GEYER</asp:ListItem>
                                        <asp:ListItem>GLEBE</asp:ListItem>
                                        <asp:ListItem>JASON BASS</asp:ListItem>
                                        <asp:ListItem>LIVERPOOL</asp:ListItem>
                                        <asp:ListItem>NARRABEEN</asp:ListItem>
                                        <asp:ListItem>SEA EAGLES</asp:ListItem>
                                        <asp:ListItem>SEA EAGLES B2B</asp:ListItem>
                                        <asp:ListItem>SEAFORTH</asp:ListItem>
                                        <asp:ListItem>SUMO SALAD</asp:ListItem>
                                        <asp:ListItem>TELEFIELD</asp:ListItem>
                                        <asp:ListItem>TIN CAN BAY</asp:ListItem>
                                        <asp:ListItem>TYREPOWER</asp:ListItem>
                                        <asp:ListItem>TYRES &amp; MORE</asp:ListItem>
                                        <asp:ListItem>WPW</asp:ListItem>   																	
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Lead Source Code" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblLeadSource" runat="server" Text='<%# bind("LeadSource")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="LeadSource" runat="server" Text='<%# Bind("LeadSource") %>' Visible="true"></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Administration Fee" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblAdminFee" runat="server" Text='<%# bind("AdminFee")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="AdminFee" runat="server" Text='<%# Bind("AdminFee") %>'></asp:TextBox>
                                    <asp:DropDownList name="selAdminFee" ID="selAdminFee" runat="Server"
                                        onchange="AdminFeeChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="0">Free</asp:ListItem>
                                        <asp:ListItem Value="50">$50</asp:ListItem>
                                        <asp:ListItem Value="100">$100</asp:ListItem>
                                        <asp:ListItem Value="200">$200</asp:ListItem>
                                        <asp:ListItem Value="300">$300</asp:ListItem>
                                        <asp:ListItem Value="400">$400</asp:ListItem>
                                        <asp:ListItem Value="500">$500</asp:ListItem>
                                        <asp:ListItem Value="600">$600</asp:ListItem>
                                        <asp:ListItem Value="700">$700</asp:ListItem>
                                        <asp:ListItem Value="800">$800</asp:ListItem>
                                        <asp:ListItem Value="900">$900</asp:ListItem>
                                        <asp:ListItem Value="1000">$1,000</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Vendor ID *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="VendorID" runat="server" Text='<%# Bind("VendorID") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Organisation Type" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblTypeOrg" runat="server" Text='<%# bind("TypeOrg")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TypeOrg" runat="server" Text='<%# Bind("TypeOrg") %>'></asp:TextBox>
                                    <asp:DropDownList name="selTypeOrg" ID="selTypeOrg" runat="Server" HeaderText="Organisation Type" onchange="TypeOrgChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="RESI">RESI</asp:ListItem>
                                        <asp:ListItem Value="SME">SME</asp:ListItem>
                                        <asp:ListItem Value="C&I">C&I</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Customer Details" HeaderStyle-Font-Size="Large" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="RESI/SME *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="RESI_SME" runat="server" Text='<%# Bind("RESI_SME") %>'></asp:TextBox>
                                    <asp:DropDownList name="selRESI_SME" ID="selRESI_SME" runat="Server" HeaderText="RESI/SME" onchange="RESI_SME_Changed()" Visible="false">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="RESI">RESI</asp:ListItem>
                                        <asp:ListItem Value="SME">SME</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Company Name *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblCompanyName" runat="server" Text='<%# bind("CompanyName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CompanyName" runat="server" Text='<%# Bind("CompanyName") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Company ABN *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblCompanyABN" runat="server" Text='<%# bind("CompanyABN")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CompanyABN" runat="server" Text='<%# Bind("CompanyABN") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="First Name" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblFirstName" runat="server" Text='<%# bind("FirstName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="FirstName" runat="server" Text='<%# Bind("FirstName") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Last Name" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblLastName" runat="server" Text='<%# bind("LastName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="LastName" runat="server" Text='<%# Bind("LastName") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="First Account Holder Title *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="FirstAccountHolderTitle" runat="server" Text='<%# Bind("FirstAccountHolderTitle") %>'></asp:TextBox>
                                    <asp:DropDownList name="selFirstAccountHolderTitle" ID="selFirstAccountHolderTitle" runat="Server" HeaderText="First Account Holder Title" onchange="FirstAccountHolderTitleChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Mr">Mr</asp:ListItem>
                                        <asp:ListItem Value="Miss">Miss</asp:ListItem>
                                        <asp:ListItem Value="Mrs">Mrs</asp:ListItem>
                                        <asp:ListItem Value="Ms">Ms</asp:ListItem>
                                        <asp:ListItem Value="Dr">Dr</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="First Account Holder First Name *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblFirstAccountHolderFirstName" runat="server" Text='<%# bind("FirstAccountHolderFirstName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="FirstAccountHolderFirstName" runat="server" Text='<%# Bind("FirstAccountHolderFirstName") %>'></asp:TextBox>
                                    <input type="button" ID="CopyName" runat="server" value="Copy Name" onclick="CopyNameClick()"/>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="First Account Holder Surname *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblFirstAccountHolderSurname" runat="server" Text='<%# bind("FirstAccountHolderSurname")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="FirstAccountHolderSurname" runat="server" Text='<%# Bind("FirstAccountHolderSurname") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="First Account Holder DOB *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblFirstAccountHolderDOB" runat="server" Text='<%# bind("FirstAccountHolderDOB")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="FirstAccountHolderDOB" runat="server"   onclick="WdatePicker({maxDate:'1994-12-30'})"  Text='<%# Bind("FirstAccountHolderDOB") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Street" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblStreet" runat="server" Text='<%# bind("Street")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Street" runat="server" Text='<%# Bind("Street") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Suburb" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblSuburb" runat="server" Text='<%# bind("Suburb")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Suburb" runat="server" Text='<%# Bind("Suburb") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="State" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                    <asp:TextBox ID="StateName" runat="server" Text='<%# Bind("StateName") %>'></asp:TextBox>    
                                    <asp:DropDownList name="selStateName" ID="selStateName" runat="Server" HeaderText="StateName" onchange="StateNameChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="ACT">ACT</asp:ListItem>
                                        <asp:ListItem Value="NSW">NSW</asp:ListItem>
                                        <asp:ListItem Value="NT">NT</asp:ListItem>
                                        <asp:ListItem Value="QLD">QLD</asp:ListItem>
                                        <asp:ListItem Value="SA">SA</asp:ListItem>
                                        <asp:ListItem Value="TAS">TAS</asp:ListItem>
                                        <asp:ListItem Value="VIC">VIC</asp:ListItem>
                                        <asp:ListItem Value="WA">WA</asp:ListItem>                     
                                    </asp:DropDownList>               
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Postcode" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblPostcode" runat="server" Text='<%# bind("Postcode")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Postcode" runat="server" Text='<%# Bind("Postcode") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Email *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblEmail" runat="server" Text='<%# bind("Email")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Email" runat="server" Text='<%# Bind("Email") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>                          
                            
                            <asp:TemplateField HeaderText="Contact Tel *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblPhone" runat="server" Text='<%# bind("Phone")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Phone" runat="server" Text='<%# Bind("Phone") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Second Tel" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblMobile" runat="server" Text='<%# bind("Mobile")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Mobile" runat="server" Text='<%# Bind("Mobile") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
   
                                <asp:TemplateField HeaderText="Contact Tel *" Visible="false" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblContactTel" runat="server" Text='<%# bind("ContactTel")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ContactTel" runat="server" Text='<%# Bind("ContactTel") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Second Tel" Visible="false" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblSecondTel" runat="server" Text='<%# bind("SecondTel")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SecondTel" runat="server" Text='<%# Bind("SecondTel") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="ID Type *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="ID_Type" runat="server" Text='<%# Bind("ID_Type") %>'></asp:TextBox>
                                    <asp:DropDownList name="selID_Type" ID="selID_Type" runat="Server" HeaderText="ID Type" onchange="ID_TypeChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="PASSPORT">PASSPORT</asp:ListItem>
                                        <asp:ListItem Value="MEDICARE">MEDICARE</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE ACT">DRIVING LICENSE ACT</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE NSW">DRIVING LICENSE NSW</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE NT">DRIVING LICENSE NT</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE QLD">DRIVING LICENSE QLD</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE SA">DRIVING LICENSE SA</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE TAS">DRIVING LICENSE TAS</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE VIC">DRIVING LICENSE VIC</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE WA">DRIVING LICENSE WA</asp:ListItem>                     
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="ID Number *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblID_Number" runat="server" Text='<%# bind("ID_Number")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ID_Number" runat="server" Text='<%# Bind("ID_Number") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="ID Expiry" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblID_Expiry" runat="server" Text='<%# bind("ID_Expiry")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ID_Expiry" runat="server" onclick="WdatePicker()" Text='<%# Bind("ID_Expiry") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Second Account Holder?" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                    <asp:DropDownList name="selSecondAccountHolder" ID="selSecondAccountHolder" runat="Server" HeaderText="Second Account Holder?" onchange="SecondAccountHolderChanged()">
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Second Account Holder Title" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="SecondAccountHolderTitle" runat="server" Text='<%# Bind("SecondAccountHolderTitle") %>'></asp:TextBox>
                                    <asp:DropDownList name="selSecondAccountHolderTitle" ID="selSecondAccountHolderTitle" runat="Server" HeaderText="Second Account Holder Title" onchange="SecondAccountHolderTitleChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Mr">Mr</asp:ListItem>
                                        <asp:ListItem Value="Miss">Miss</asp:ListItem>
                                        <asp:ListItem Value="Mrs">Mrs</asp:ListItem>
                                        <asp:ListItem Value="Ms">Ms</asp:ListItem>
                                        <asp:ListItem Value="Dr">Dr</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            
                            <asp:TemplateField HeaderText="Second Account Holder First Name" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblSecondAccountHolderFirstName" runat="server" Text='<%# bind("SecondAccountHolderFirstName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SecondAccountHolderFirstName" runat="server" Text='<%# Bind("SecondAccountHolderFirstName") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Second Account Holder Surname" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblSecondAccountHolderSurname" runat="server" Text='<%# bind("SecondAccountHolderSurname")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SecondAccountHolderSurname" runat="server" Text='<%# Bind("SecondAccountHolderSurname") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Second Account Holder DOB" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblSecondAccountHolderDOB" runat="server" Text='<%# bind("SecondAccountHolderDOB")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SecondAccountHolderDOB" runat="server" onclick="WdatePicker()" Text='<%# Bind("SecondAccountHolderDOB") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Concession Card?" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                    <asp:DropDownList name="selConcessionCard" ID="selConcessionCard" runat="Server" HeaderText="Concession Card?" onchange="ConcessionCardChanged()">
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Concession Card Type" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="ConcessionCardType" runat="server" Text='<%# Bind("ConcessionCardType") %>'></asp:TextBox>
                                    <asp:DropDownList name="selConcessionCardType" ID="selConcessionCardType" runat="Server" HeaderText="Concession Card Type" onchange="ConcessionCardTypeChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Pensioner">Pensioner</asp:ListItem>
                                        <asp:ListItem Value="Govt Building">Govt Building</asp:ListItem>
                                        <asp:ListItem Value="Other">Other</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Concession Card Entitlement" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblConcessionCardEntitlement" runat="server" Text='<%# bind("ConcessionCardEntitlement")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ConcessionCardEntitlement" runat="server" Text='<%# Bind("ConcessionCardEntitlement") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Concession Card Number" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblConcessionCardNo" runat="server" Text='<%# bind("ConcessionCardNo")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ConcessionCardNo" runat="server" Text='<%# Bind("ConcessionCardNo") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Concession Card Expiry" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblConcessionCardExp" runat="server" Text='<%# bind("ConcessionCardExp")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ConcessionCardExp" runat="server" onclick="WdatePicker()" Text='<%# Bind("ConcessionCardExp") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Name On Concession Card" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblNameOnConcessionCard" runat="server" Text='<%# bind("NameOnConcessionCard")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="NameOnConcessionCard" runat="server" Text='<%# Bind("NameOnConcessionCard") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Electricity Conversion *" HeaderStyle-Font-Size="Large" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="ElectricityConversion" runat="server" Text='<%# Bind("ElectricityConversion") %>'></asp:TextBox>
                                    <asp:DropDownList name="selElectricityConversion" ID="selElectricityConversion" runat="Server" HeaderText="Electricity Conversion" onchange="ElectricityConversionChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Elec? *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="Elec" runat="server" Text='<%# Bind("Elec") %>'></asp:TextBox>
                                    <asp:DropDownList name="selElec" ID="selElec" runat="Server" HeaderText="Elec" onchange="ElecChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="NMI *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblNMI" runat="server" Text='<%# bind("NMI")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="NMI" runat="server" Text='<%# Bind("NMI") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Electricity Month/Quarter" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="ElecMonthQuarter" runat="server" Text='<%# Bind("ElecMonthQuarter") %>'></asp:TextBox>
                                    <asp:DropDownList name="selElecMonthQuarter" ID="selElecMonthQuarter" runat="Server" onchange="ElecMonthQuarterChanged()" HeaderText="Electricity Month/Quarter">
									    <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Month">Month</asp:ListItem>
                                        <asp:ListItem Value="Quarter">Quarter</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Electricity Monthly/Quarterly Spend" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="ElecMonthQuarterSpend" runat="server" Text='<%# Bind("ElecMonthQuarterSpend") %>'></asp:TextBox>
                                    <asp:DropDownList name="selElecSpend" ID="selElecSpend" runat="Server"
                                        onchange="ElecSpendChanged()" HeaderText="Electricity Monthly/Quarterly Spend">
                                        <asp:ListItem Value="0">Select...</asp:ListItem>
                                        <asp:ListItem Value="50">$50</asp:ListItem>
                                        <asp:ListItem Value="100">$100</asp:ListItem>
                                        <asp:ListItem Value="150">$150</asp:ListItem>
                                        <asp:ListItem Value="200">$200</asp:ListItem>
                                        <asp:ListItem Value="250">$250</asp:ListItem>
                                        <asp:ListItem Value="300">$300</asp:ListItem>
                                        <asp:ListItem Value="350">$350</asp:ListItem>
                                        <asp:ListItem Value="400">$400</asp:ListItem>
                                        <asp:ListItem Value="450">$450</asp:ListItem>
                                        <asp:ListItem Value="500">$500</asp:ListItem>
                                        <asp:ListItem Value="550">$550</asp:ListItem>
                                        <asp:ListItem Value="600">$600</asp:ListItem>
                                        <asp:ListItem Value="650">$650</asp:ListItem>
                                        <asp:ListItem Value="700">$700</asp:ListItem>
                                        <asp:ListItem Value="750">$750</asp:ListItem>
                                        <asp:ListItem Value="800">$800</asp:ListItem>
                                        <asp:ListItem Value="850">$850</asp:ListItem>
                                        <asp:ListItem Value="900">$900</asp:ListItem>
                                        <asp:ListItem Value="950">$950</asp:ListItem>
                                        <asp:ListItem Value="1000">$1,000</asp:ListItem>
                                        <asp:ListItem Value="1500">$1,500</asp:ListItem>
                                        <asp:ListItem Value="2000">$2,000</asp:ListItem>
                                        <asp:ListItem Value="2500">$2,500</asp:ListItem>
                                        <asp:ListItem Value="3000">$3,000</asp:ListItem>
                                        <asp:ListItem Value="3500">$3,500</asp:ListItem>
                                        <asp:ListItem Value="4000">$4,000</asp:ListItem>
                                        <asp:ListItem Value="4500">$4,500</asp:ListItem>
                                        <asp:ListItem Value="5000">$5,000</asp:ListItem>
                                        <asp:ListItem Value="5500">$5,500</asp:ListItem>
                                        <asp:ListItem Value="6000">$6,000</asp:ListItem>
                                        <asp:ListItem Value="6500">$6,500</asp:ListItem>
                                        <asp:ListItem Value="7000">$7,000</asp:ListItem>
                                        <asp:ListItem Value="7500">$7,500</asp:ListItem>
                                        <asp:ListItem Value="8000">$8,000</asp:ListItem>
                                        <asp:ListItem Value="8500">$8,500</asp:ListItem>
                                        <asp:ListItem Value="9000">$9,000</asp:ListItem>
                                        <asp:ListItem Value="9500">$9,500</asp:ListItem>
                                        <asp:ListItem Value="10000">$10,000</asp:ListItem>
                                        <asp:ListItem Value="15000">$15,000</asp:ListItem>
                                        <asp:ListItem Value="20000">$20,000</asp:ListItem>
                                        <asp:ListItem Value="25000">$25,000</asp:ListItem>
                                        <asp:ListItem Value="30000">$30,000</asp:ListItem>
                                        <asp:ListItem Value="35000">$35,000</asp:ListItem>
                                        <asp:ListItem Value="40000">$40,000</asp:ListItem>
                                        <asp:ListItem Value="45000">$45,000</asp:ListItem>
                                        <asp:ListItem Value="50000">$50,000</asp:ListItem>
                                        <asp:ListItem Value="55000">$55,000</asp:ListItem>
                                        <asp:ListItem Value="60000">$60,000</asp:ListItem>
                                        <asp:ListItem Value="65000">$65,000</asp:ListItem>
                                        <asp:ListItem Value="70000">$70,000</asp:ListItem>
                                        <asp:ListItem Value="75000">$75,000</asp:ListItem>
                                        <asp:ListItem Value="80000">$80,000</asp:ListItem>
                                        <asp:ListItem Value="85000">$85,000</asp:ListItem>
                                        <asp:ListItem Value="90000">$90,000</asp:ListItem>
                                        <asp:ListItem Value="95000">$95,000</asp:ListItem>
                                        <asp:ListItem Value="100000">$100,000</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Electricity Annual Spend *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblElecTotalAnnualSpend" runat="server" Text='<%# bind("ElecTotalAnnualSpend")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ElecTotalAnnualSpend" runat="server" Text='<%# Bind("ElecTotalAnnualSpend") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas Conversion *" HeaderStyle-Font-Size="Large"  HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="GasConversion" runat="server" Text='<%# Bind("GasConversion") %>'></asp:TextBox>
                                    <asp:DropDownList name="selGasConversion" ID="selGasConversion" runat="Server" HeaderText="Gas Conversion" onchange="GasConversionChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas? *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="Gas" runat="server" Text='<%# Bind("Gas") %>'></asp:TextBox>
                                    <asp:DropDownList name="selGas" ID="selGas" runat="Server" HeaderText="Gas" onchange="GasChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="MIRN *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblMIRN" runat="server" Text='<%# bind("MIRN")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="MIRN" runat="server" Text='<%# Bind("MIRN") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas Month/Quarter" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="GasMonthQuarter" runat="server" Text='<%# Bind("GasMonthQuarter") %>'></asp:TextBox>			
                                    <asp:DropDownList name="selGasMonthQuarter" ID="selGasMonthQuarter" runat="Server" onchange="GasMonthQuarterChanged()" HeaderText="Gas Month/Quarter">
										<asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Month">Month</asp:ListItem>
                                        <asp:ListItem Value="Quarter">Quarter</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas Monthly/Quarterly Spend" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="GasMonthQuarterSpend" runat="server" Text='<%# Bind("GasMonthQuarterSpend") %>'></asp:TextBox>	
                                    <asp:DropDownList name="selGasSpend" ID="selGasSpend" runat="Server"
                                        onchange="GasSpendChanged()" HeaderText="Gas Monthly/Quarterly Spend">
                                        <asp:ListItem Value="0">Select...</asp:ListItem>
                                        <asp:ListItem Value="50">$50</asp:ListItem>
                                        <asp:ListItem Value="100">$100</asp:ListItem>
                                        <asp:ListItem Value="150">$150</asp:ListItem>
                                        <asp:ListItem Value="200">$200</asp:ListItem>
                                        <asp:ListItem Value="250">$250</asp:ListItem>
                                        <asp:ListItem Value="300">$300</asp:ListItem>
                                        <asp:ListItem Value="350">$350</asp:ListItem>
                                        <asp:ListItem Value="400">$400</asp:ListItem>
                                        <asp:ListItem Value="450">$450</asp:ListItem>
                                        <asp:ListItem Value="500">$500</asp:ListItem>
                                        <asp:ListItem Value="550">$550</asp:ListItem>
                                        <asp:ListItem Value="600">$600</asp:ListItem>
                                        <asp:ListItem Value="650">$650</asp:ListItem>
                                        <asp:ListItem Value="700">$700</asp:ListItem>
                                        <asp:ListItem Value="750">$750</asp:ListItem>
                                        <asp:ListItem Value="800">$800</asp:ListItem>
                                        <asp:ListItem Value="850">$850</asp:ListItem>
                                        <asp:ListItem Value="900">$900</asp:ListItem>
                                        <asp:ListItem Value="950">$950</asp:ListItem>
                                        <asp:ListItem Value="1000">$1,000</asp:ListItem>
                                        <asp:ListItem Value="1500">$1,500</asp:ListItem>
                                        <asp:ListItem Value="2000">$2,000</asp:ListItem>
                                        <asp:ListItem Value="2500">$2,500</asp:ListItem>
                                        <asp:ListItem Value="3000">$3,000</asp:ListItem>
                                        <asp:ListItem Value="3500">$3,500</asp:ListItem>
                                        <asp:ListItem Value="4000">$4,000</asp:ListItem>
                                        <asp:ListItem Value="4500">$4,500</asp:ListItem>
                                        <asp:ListItem Value="5000">$5,000</asp:ListItem>
                                        <asp:ListItem Value="5500">$5,500</asp:ListItem>
                                        <asp:ListItem Value="6000">$6,000</asp:ListItem>
                                        <asp:ListItem Value="6500">$6,500</asp:ListItem>
                                        <asp:ListItem Value="7000">$7,000</asp:ListItem>
                                        <asp:ListItem Value="7500">$7,500</asp:ListItem>
                                        <asp:ListItem Value="8000">$8,000</asp:ListItem>
                                        <asp:ListItem Value="8500">$8,500</asp:ListItem>
                                        <asp:ListItem Value="9000">$9,000</asp:ListItem>
                                        <asp:ListItem Value="9500">$9,500</asp:ListItem>
                                        <asp:ListItem Value="10000">$10,000</asp:ListItem>
                                        <asp:ListItem Value="15000">$15,000</asp:ListItem>
                                        <asp:ListItem Value="20000">$20,000</asp:ListItem>
                                        <asp:ListItem Value="25000">$25,000</asp:ListItem>
                                        <asp:ListItem Value="30000">$30,000</asp:ListItem>
                                        <asp:ListItem Value="35000">$35,000</asp:ListItem>
                                        <asp:ListItem Value="40000">$40,000</asp:ListItem>
                                        <asp:ListItem Value="45000">$45,000</asp:ListItem>
                                        <asp:ListItem Value="50000">$50,000</asp:ListItem>
                                        <asp:ListItem Value="55000">$55,000</asp:ListItem>
                                        <asp:ListItem Value="60000">$60,000</asp:ListItem>
                                        <asp:ListItem Value="65000">$65,000</asp:ListItem>
                                        <asp:ListItem Value="70000">$70,000</asp:ListItem>
                                        <asp:ListItem Value="75000">$75,000</asp:ListItem>
                                        <asp:ListItem Value="80000">$80,000</asp:ListItem>
                                        <asp:ListItem Value="85000">$85,000</asp:ListItem>
                                        <asp:ListItem Value="90000">$90,000</asp:ListItem>
                                        <asp:ListItem Value="95000">$95,000</asp:ListItem>
                                        <asp:ListItem Value="100000">$100,000</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas Annual Spend *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblGasTotalAnnualSpend" runat="server" Text='<%# bind("GasTotalAnnualSpend")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="GasTotalAnnualSpend" runat="server" Text='<%# Bind("GasTotalAnnualSpend") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Product Information" HeaderStyle-Font-Size="Large" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Total Annual Spend" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblTotalAnnualSpend" runat="server" Text='<%# bind("TotalAnnualSpend")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TotalAnnualSpend" runat="server" Text='<%# Bind("TotalAnnualSpend") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Current Provider" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblcurrprovider" runat="server" Text='<%# bind("CurrentProvider")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CurrentProvider" runat="server" Text='<%# Bind("CurrentProvider") %>'></asp:TextBox>
                                    <select name="selcurrprovider" id="selcurrprovider">
                                        <option>Select... </option>
                                        <option>AGL </option>
                                        <option>Alinta </option>
                                        <option>Aurora Energy Pty Ltd</option>
                                        <option>Australian Power and Gas </option>
                                        <option>Click Energy</option>
                                        <option>Cogent Energy </option>
                                        <option>Essential Energy</option>
                                        <option>Country Energy </option>
                                        <option>Delta Electricity</option>
                                        <option>Diamond Energy </option>
                                        <option>Dodo Power & Gas </option>
                                        <option>Energy Australia </option>
                                        <option>Ergon Energy Queensland</option>
                                        <option>ERM Power Retail Pty Ltd</option>
                                        <option>Eraring Energy</option>
                                        <option>Essential Energy</option>
                                        <option>Flinders Power Holding GmbH</option>
                                        <option>GridX Pty Ltd</option>
                                        <option>Independent Electricity Retail Solutions Pty Ltd </option>
                                        <option>Integral Energy Australia </option>
                                        <option>Lumo Energy </option>
                                        <option>Momentum Energy </option>
                                        <option>Neighbourhood Energy</option>
                                        <option>Origin Energy </option>
                                        <option>Powerdirect </option>
                                        <option>Qenergy</option>
                                        <option>Red Energy </option>
                                        <option>Sanctuary Energy </option>
                                        <option>Simply Energy</option>
                                        <option>Tarong Energy </option>
                                        <option>TRUenergy </option>
                                        <option>Trustpower Australia </option>
                                        <option>Victoria Electricity</option>
                                    </select>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="New Provider" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblRetailerName" runat="server" Text='<%# bind("ProviderID")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:HiddenField ID="ProviderID" runat="server" Value='<%# Bind("ProviderID") %>'>
                                    </asp:HiddenField>
                                    <asp:DropDownList name="selProviderID" ID="selProviderID" runat="Server">
                                    <asp:ListItem Value="TRUenergy ">TRUenergy </asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Source Code *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="SourceCode" runat="server" Text='<%# Bind("SourceCode") %>'></asp:TextBox>                                   
                                    <asp:DropDownList name="selSourceCode" ID="selSourceCode" runat="Server" HeaderText="Source Code" onchange="SourceCodeChanged()" Visible="false">
                                        <asp:ListItem Value="">Select...</asp:ListItem>       
                                        <asp:ListItem Value="STREETSMART_EDGE_14%VD_REB">STREETSMART_EDGE_14%VD_REB</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_12%VD_REB">STREETSMART_EDGE_12%VD_REB</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_17%VD‏">STREETSMART_EDGE_17%VD‏</asp:ListItem>
										<asp:ListItem Value="STREETSMART_EDGE_14%VD">STREETSMART_EDGE_14%VD</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_12%VD">STREETSMART_EDGE_12%VD</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_10%VD">STREETSMART_EDGE_10%VD</asp:ListItem>                                       
                                        <asp:ListItem Value="STREETSMART_7%PDD">STREETSMART_7%PDD</asp:ListItem>
										<asp:ListItem Value="STREETSMART_5%PDD">STREETSMART_5%PDD</asp:ListItem> 
                                        <asp:ListItem Value="STREETSMART_RES">STREETSMART_RES</asp:ListItem>
										<asp:ListItem Value="GROUPBUY_9%PDD">GROUPBUY_9%PDD</asp:ListItem>
                                        <asp:ListItem Value="BULKRES_OFFER3">BULKRES_OFFER3</asp:ListItem>
                                        <asp:ListItem Value="EXEL_8%PDD">EXEL_8%PDD</asp:ListItem>
                                    </asp:DropDownList> 
                                    <asp:DropDownList name="selSourceCodeRESI" ID="selSourceCodeRESI" runat="Server" HeaderText="Source Code" onchange="SourceCodeRESIChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>                                            
                                        <asp:ListItem Value="STREETSMART_7%PDD">STREETSMART_7%PDD</asp:ListItem>
										<asp:ListItem Value="STREETSMART_5%PDD">STREETSMART_5%PDD</asp:ListItem> 
                                        <asp:ListItem Value="STREETSMART_RES">STREETSMART_RES</asp:ListItem>
										<asp:ListItem Value="GROUPBUY_9%PDD">GROUPBUY_9%PDD</asp:ListItem>
                                        <asp:ListItem Value="BULKRES_OFFER3">BULKRES_OFFER3</asp:ListItem>
                                        <asp:ListItem Value="EXEL_8%PDD">EXEL_8%PDD</asp:ListItem>
                                        <asp:ListItem Value="ISELECT_11%PDD">ISELECT_11%PDD</asp:ListItem>
                                    </asp:DropDownList> 
                                    <asp:DropDownList name="selSourceCodeSME" ID="selSourceCodeSME" runat="Server" HeaderText="Source Code" onchange="SourceCodeSMEChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>       
                                        <asp:ListItem Value="STREETSMART_EDGE_14%VD_REB">STREETSMART_EDGE_14%VD_REB</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_12%VD_REB">STREETSMART_EDGE_12%VD_REB</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_17%VD‏">STREETSMART_EDGE_17%VD‏</asp:ListItem>
										<asp:ListItem Value="STREETSMART_EDGE_14%VD">STREETSMART_EDGE_14%VD</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_12%VD">STREETSMART_EDGE_12%VD</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_10%VD">STREETSMART_EDGE_10%VD</asp:ListItem>                                       
                                    </asp:DropDownList> 
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Product Type *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="ProductType" runat="server" Text='<%# Bind("ProductType") %>'></asp:TextBox>
                                    <asp:DropDownList name="selProductType" ID="selProductType" runat="Server" HeaderText="Product Type" onchange="ProductTypeChanged()" Visible="false">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="PEAK_ONLY">PEAK_ONLY</asp:ListItem>
                                        <asp:ListItem Value="OFF_PEAK">OFF_PEAK</asp:ListItem>
                                        <asp:ListItem Value="PEAK/OFF_PEAK">PEAK/OFF_PEAK</asp:ListItem>
                                        <asp:ListItem Value="TOU">TOU</asp:ListItem>
                                        <asp:ListItem Value="BUSINESSEDGE">BUSINESSEDGE</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE">GOFORMORE</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_PEAKONLY">BUSEDGE_PEAKONLY</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_OFFPEAK">BUSEDGE_OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_PEAK/OFFPEAK">BUSEDGE_PEAK/OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_TOU">BUSEDGE_TOU</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_PEAKONLY">GOFORMORE_PEAKONLY</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_OFFPEAK">GOFORMORE_OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_PEAK/OFFPEAK">GOFORMORE_PEAK/OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_TOU">GOFORMORE_TOU</asp:ListItem>  										
                                    </asp:DropDownList>
                                    <asp:DropDownList name="selProductTypeRESI" ID="selProductTypeRESI" runat="Server" HeaderText="Product Type" onchange="ProductTypeRESIChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="PEAK_ONLY">PEAK_ONLY</asp:ListItem>
                                        <asp:ListItem Value="OFF_PEAK">OFF_PEAK</asp:ListItem>
                                        <asp:ListItem Value="PEAK/OFF_PEAK">PEAK/OFF_PEAK</asp:ListItem>
                                        <asp:ListItem Value="TOU">TOU</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE">GOFORMORE</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_PEAKONLY">GOFORMORE_PEAKONLY</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_OFFPEAK">GOFORMORE_OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_PEAK/OFFPEAK">GOFORMORE_PEAK/OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_TOU">GOFORMORE_TOU</asp:ListItem>  										
                                    </asp:DropDownList>
                                    <asp:DropDownList name="selProductTypeSME" ID="selProductTypeSME" runat="Server" HeaderText="Product Type" onchange="ProductTypeSMEChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="PEAK_ONLY">PEAK_ONLY</asp:ListItem>
                                        <asp:ListItem Value="OFF_PEAK">OFF_PEAK</asp:ListItem>
                                        <asp:ListItem Value="PEAK/OFF_PEAK">PEAK/OFF_PEAK</asp:ListItem>
                                        <asp:ListItem Value="TOU">TOU</asp:ListItem>
                                        <asp:ListItem Value="BUSINESSEDGE">BUSINESSEDGE</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_PEAKONLY">BUSEDGE_PEAKONLY</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_OFFPEAK">BUSEDGE_OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_PEAK/OFFPEAK">BUSEDGE_PEAK/OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_TOU">BUSEDGE_TOU</asp:ListItem>									
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Property Details" HeaderStyle-Font-Size="Large" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Mover/Swicher *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="MoverSwicher" runat="server" Text='<%# Bind("MoverSwicher") %>'></asp:TextBox>
                                    <asp:DropDownList name="selMoverSwicher" ID="selMoverSwicher" runat="Server" HeaderText="Mover/Swicher" onchange="MoverSwicherChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Mover">Mover</asp:ListItem>
                                        <asp:ListItem Value="Swicher">Swicher</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Move In Date *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblMoveInDate" runat="server" Text='<%# bind("MoveInDate")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="MoveInDate" runat="server" onclick="WdatePicker()" Text='<%# Bind("MoveInDate") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Supply Address *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblSupplyAddress" runat="server" Text='<%# bind("SupplyAddress")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SupplyAddress" runat="server" Text='<%# Bind("SupplyAddress") %>'></asp:TextBox>
                                    <input type="button" ID="CopyAddress" runat="server" value="Copy Address" onclick="CopyAddressClick()"/>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Supply Address Suburb *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblSupplyAddressSuburb" runat="server" Text='<%# bind("SupplyAddressSuburb")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SupplyAddressSuburb" runat="server" Text='<%# Bind("SupplyAddressSuburb") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Supply Address State *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="SupplyAddressState" runat="server" Text='<%# Bind("SupplyAddressState") %>'></asp:TextBox>
                                    <asp:DropDownList name="selSupplyAddressState" ID="selSupplyAddressState" runat="Server" HeaderText="Supply Address State" onchange="SupplyAddressStateChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="ACT">ACT</asp:ListItem>
                                        <asp:ListItem Value="NSW">NSW</asp:ListItem>
                                        <asp:ListItem Value="NT">NT</asp:ListItem>
                                        <asp:ListItem Value="QLD">QLD</asp:ListItem>
                                        <asp:ListItem Value="SA">SA</asp:ListItem>
                                        <asp:ListItem Value="TAS">TAS</asp:ListItem>
                                        <asp:ListItem Value="VIC">VIC</asp:ListItem>
                                        <asp:ListItem Value="WA">WA</asp:ListItem>                     
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Supply Address Postcode *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblSupplyAddressPostcode" runat="server" Text='<%# bind("SupplyAddressPostcode")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SupplyAddressPostcode" runat="server" Text='<%# Bind("SupplyAddressPostcode") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Total Sites" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="TotalSites" runat="server" Text='<%# Bind("TotalSites") %>'></asp:TextBox>
                                    <asp:DropDownList name="selTotalSites" ID="selTotalSites" runat="Server" HeaderText="Total Sites"  onchange="TotalSitesChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="1">1</asp:ListItem>
                                        <asp:ListItem Value="2">2</asp:ListItem>
                                        <asp:ListItem Value="3">3</asp:ListItem>
                                        <asp:ListItem Value="4">4</asp:ListItem>
                                        <asp:ListItem Value="5">5</asp:ListItem>
                                        <asp:ListItem Value="6">6</asp:ListItem>
                                        <asp:ListItem Value="7">7</asp:ListItem>
                                        <asp:ListItem Value="8">8</asp:ListItem>
                                        <asp:ListItem Value="9">9</asp:ListItem>
                                        <asp:ListItem Value="10">10</asp:ListItem>
                                        <asp:ListItem Value="11">11</asp:ListItem>
                                        <asp:ListItem Value="12">12</asp:ListItem>
                                        <asp:ListItem Value="13">13</asp:ListItem>
                                        <asp:ListItem Value="14">14</asp:ListItem>
                                        <asp:ListItem Value="15">15</asp:ListItem>
                                        <asp:ListItem Value="16">16</asp:ListItem>
                                        <asp:ListItem Value="17">17</asp:ListItem>
                                        <asp:ListItem Value="18">18</asp:ListItem>
                                        <asp:ListItem Value="19">19</asp:ListItem>
                                        <asp:ListItem Value="20">20</asp:ListItem>
                                        <asp:ListItem Value="21">21</asp:ListItem>
                                        <asp:ListItem Value="22">22</asp:ListItem>
                                        <asp:ListItem Value="23">23</asp:ListItem>
                                        <asp:ListItem Value="24">24</asp:ListItem>
                                        <asp:ListItem Value="25">25</asp:ListItem>
                                        <asp:ListItem Value="26">26</asp:ListItem>
                                        <asp:ListItem Value="27">27</asp:ListItem>
                                        <asp:ListItem Value="28">28</asp:ListItem>
                                        <asp:ListItem Value="29">29</asp:ListItem>
                                        <asp:ListItem Value="30">30</asp:ListItem>
                                        <asp:ListItem Value="31">31</asp:ListItem>
                                        <asp:ListItem Value="32">32</asp:ListItem>
                                        <asp:ListItem Value="33">33</asp:ListItem>
                                        <asp:ListItem Value="34">34</asp:ListItem>
                                        <asp:ListItem Value="35">35</asp:ListItem>
                                        <asp:ListItem Value="36">36</asp:ListItem>
                                        <asp:ListItem Value="37">37</asp:ListItem>
                                        <asp:ListItem Value="38">38</asp:ListItem>
                                        <asp:ListItem Value="39">39</asp:ListItem>
                                        <asp:ListItem Value="40">40</asp:ListItem>
                                        <asp:ListItem Value="41">41</asp:ListItem>
                                        <asp:ListItem Value="42">42</asp:ListItem>
                                        <asp:ListItem Value="43">43</asp:ListItem>
                                        <asp:ListItem Value="44">44</asp:ListItem>
                                        <asp:ListItem Value="45">45</asp:ListItem>
                                        <asp:ListItem Value="46">46</asp:ListItem>
                                        <asp:ListItem Value="47">47</asp:ListItem>
                                        <asp:ListItem Value="48">48</asp:ListItem>
                                        <asp:ListItem Value="49">49</asp:ListItem>
                                        <asp:ListItem Value="50">50</asp:ListItem>
                                        <asp:ListItem Value="60">60</asp:ListItem>
                                        <asp:ListItem Value="70">70</asp:ListItem>
                                        <asp:ListItem Value="80">80</asp:ListItem>
                                        <asp:ListItem Value="90">90</asp:ListItem>
                                        <asp:ListItem Value="100">100</asp:ListItem>
                                        <asp:ListItem Value="120">120</asp:ListItem>
                                        <asp:ListItem Value="140">140</asp:ListItem>
                                        <asp:ListItem Value="160">160</asp:ListItem>
                                        <asp:ListItem Value="180">180</asp:ListItem>
                                        <asp:ListItem Value="200">200</asp:ListItem>
                                        <asp:ListItem Value="220">220</asp:ListItem>
                                        <asp:ListItem Value="240">240</asp:ListItem>
                                        <asp:ListItem Value="250">250</asp:ListItem>
                                        <asp:ListItem Value="260">260</asp:ListItem>
                                        <asp:ListItem Value="280">280</asp:ListItem>
                                        <asp:ListItem Value="300">300</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Tenant/Owner *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="TenantOwner" runat="server" Text='<%# Bind("TenantOwner") %>'></asp:TextBox>
                                    <asp:DropDownList name="selTenantOwner" ID="selTenantOwner" runat="Server" HeaderText="Tenant/Owner" onchange="TenantOwnerChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Tenant">Tenant</asp:ListItem>
                                        <asp:ListItem Value="Owner">Owner</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Number Of People In House" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="NoOfPeopleInHouse" runat="server" Text='<%# Bind("NoOfPeopleInHouse") %>'></asp:TextBox>
                                    <asp:DropDownList name="selNoOfPeopleInHouse" ID="selNoOfPeopleInHouse" runat="Server" HeaderText="No Of People In House" onchange="NoOfPeopleInHouseChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="1">1</asp:ListItem>
                                        <asp:ListItem Value="2">2</asp:ListItem>
                                        <asp:ListItem Value="3">3</asp:ListItem>
                                        <asp:ListItem Value="4">4</asp:ListItem>
                                        <asp:ListItem Value="5">5</asp:ListItem>
                                        <asp:ListItem Value="6">6</asp:ListItem>
                                        <asp:ListItem Value="7">7</asp:ListItem>
                                        <asp:ListItem Value="8">8</asp:ListItem>
                                        <asp:ListItem Value="9">9</asp:ListItem>
                                        <asp:ListItem Value="10">10</asp:ListItem>
                                        <asp:ListItem Value="11">11</asp:ListItem>
                                        <asp:ListItem Value="12">12</asp:ListItem>
                                        <asp:ListItem Value="13">13</asp:ListItem>
                                        <asp:ListItem Value="14">14</asp:ListItem>
                                        <asp:ListItem Value="15">15</asp:ListItem>
                                        <asp:ListItem Value="16">16</asp:ListItem>
                                        <asp:ListItem Value="17">17</asp:ListItem>
                                        <asp:ListItem Value="18">18</asp:ListItem>
                                        <asp:ListItem Value="19">19</asp:ListItem>
                                        <asp:ListItem Value="20">20</asp:ListItem>
                                        <asp:ListItem Value="21">21</asp:ListItem>
                                        <asp:ListItem Value="22">22</asp:ListItem>
                                        <asp:ListItem Value="23">23</asp:ListItem>
                                        <asp:ListItem Value="24">24</asp:ListItem>
                                        <asp:ListItem Value="25">25</asp:ListItem>
                                        <asp:ListItem Value="26">26</asp:ListItem>
                                        <asp:ListItem Value="27">27</asp:ListItem>
                                        <asp:ListItem Value="28">28</asp:ListItem>
                                        <asp:ListItem Value="29">29</asp:ListItem>
                                        <asp:ListItem Value="30">30</asp:ListItem>
                                        <asp:ListItem Value="31">31</asp:ListItem>
                                        <asp:ListItem Value="32">32</asp:ListItem>
                                        <asp:ListItem Value="33">33</asp:ListItem>
                                        <asp:ListItem Value="34">34</asp:ListItem>
                                        <asp:ListItem Value="35">35</asp:ListItem>
                                        <asp:ListItem Value="36">36</asp:ListItem>
                                        <asp:ListItem Value="37">37</asp:ListItem>
                                        <asp:ListItem Value="38">38</asp:ListItem>
                                        <asp:ListItem Value="39">39</asp:ListItem>
                                        <asp:ListItem Value="40">40</asp:ListItem>
                                        <asp:ListItem Value="41">41</asp:ListItem>
                                        <asp:ListItem Value="42">42</asp:ListItem>
                                        <asp:ListItem Value="43">43</asp:ListItem>
                                        <asp:ListItem Value="44">44</asp:ListItem>
                                        <asp:ListItem Value="45">45</asp:ListItem>
                                        <asp:ListItem Value="46">46</asp:ListItem>
                                        <asp:ListItem Value="47">47</asp:ListItem>
                                        <asp:ListItem Value="48">48</asp:ListItem>
                                        <asp:ListItem Value="49">49</asp:ListItem>
                                        <asp:ListItem Value="50">50</asp:ListItem>
                                        <asp:ListItem Value="60">60</asp:ListItem>
                                        <asp:ListItem Value="70">70</asp:ListItem>
                                        <asp:ListItem Value="80">80</asp:ListItem>
                                        <asp:ListItem Value="90">90</asp:ListItem>
                                        <asp:ListItem Value="100">100</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>
                         
                            <asp:TemplateField HeaderText="Any Hazards?" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblAnyHazards" runat="server" Text='<%# bind("AnyHazards")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="AnyHazards" runat="server" TextMode="MultiLine" Text='<%# Bind("AnyHazards") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Any Access Requirements?" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblAnyAccessRequirements" runat="server" Text='<%# bind("AnyAccessRequirements")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="AnyAccessRequirements" runat="server" TextMode="MultiLine" Text='<%# Bind("AnyAccessRequirements") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Special Instructions For Access?" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblSpecialInstructionsForAccess" runat="server" Text='<%# bind("SpecialInstructionsForAccess")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SpecialInstructionsForAccess" runat="server" TextMode="MultiLine" Text='<%# Bind("SpecialInstructionsForAccess") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Advised Main Switch Needs Turning Off?" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="AdvisedMainSwitchNeedsTurningOff" runat="server" Text='<%# Bind("AdvisedMainSwitchNeedsTurningOff") %>'></asp:TextBox>
                                    <asp:DropDownList name="selAdvisedMainSwitchNeedsTurningOff" ID="selAdvisedMainSwitchNeedsTurningOff" runat="Server" HeaderText="Advised Main Switch Needs TurningOff" onchange="AdvisedMainSwitchNeedsTurningOffChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Safety Certificate Required?" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="SafetyCertificateRequired" runat="server" Text='<%# Bind("SafetyCertificateRequired") %>'></asp:TextBox>
                                    <asp:DropDownList name="selSafetyCertificateRequired" ID="selSafetyCertificateRequired" runat="Server" HeaderText="Safety Certificate Required" onchange="SafetyCertificateRequiredChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Elec Status" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="ElecStatus" runat="server" Text='<%# Bind("ElecStatus") %>'></asp:TextBox>
                                    <asp:DropDownList name="selElecStatus" ID="selElecStatus" runat="Server" HeaderText="Elec Status" onchange="ElecStatusChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Accepted">Accepted</asp:ListItem>
                                        <asp:ListItem Value="Rejected">Rejected</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas Status" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="GasStatus" runat="server" Text='<%# Bind("GasStatus") %>'></asp:TextBox>
                                    <asp:DropDownList name="selGasStatus" ID="selGasStatus" runat="Server" HeaderText="Gas Status" onchange="GasStatusChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Accepted">Accepted</asp:ListItem>
                                        <asp:ListItem Value="Rejected">Rejected</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Reason" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="Reason" runat="server" Text='<%# Bind("Reason") %>'></asp:TextBox>
                                    <asp:DropDownList name="selReason" ID="selReason" runat="Server" HeaderText="Reason" onchange="ReasonChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="NMI unable to be located">NMI unable to be located</asp:ListItem>
                                        <asp:ListItem Value="Solar tariffs/product not available">Solar tariffs/product not available</asp:ListItem>
                                        <asp:ListItem Value="Existing customer on same product">Existing customer on same product</asp:ListItem>
                                        <asp:ListItem Value="Incorrect/missing information">Incorrect/missing information</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Existing TRUEnergy Customer? *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="ExistingTRUEnergyCustomer" runat="server" Text='<%# Bind("ExistingTRUEnergyCustomer") %>'></asp:TextBox>
                                    <asp:DropDownList name="selExistingTRUEnergyCustomer" ID="selExistingTRUEnergyCustomer" runat="Server" HeaderText="Existing TRUEnergy Customer" onchange="ExistingTRUEnergyCustomerChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Additional Question" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                Do you have any other properties we could look at for you?
                                <asp:TextBox ID="AdditionalQuestion" runat="server" Text='<%# Bind("AdditionalQuestion") %>'></asp:TextBox>
                                    <asp:DropDownList name="selAdditionalQuestion" ID="selAdditionalQuestion" runat="Server" HeaderText="Additional Question" onchange="AdditionalQuestionChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Investment property">Investment property</asp:ListItem>
                                        <asp:ListItem Value="Business">Business</asp:ListItem>
                                        <asp:ListItem Value="Holiday home">Holiday home</asp:ListItem>
                                        <asp:ListItem Value="Investment property & business">Investment property & business</asp:ListItem>
                                        <asp:ListItem Value="Other">Other</asp:ListItem>
                                    </asp:DropDownList>
                                    <input type="button" ID="CheckBotton" runat="server" value="Validate" onclick="checkbottonclick()" visible="false" />
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="SSE Operator Comments" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblSSE_Operator_Feedback" runat="server" Text='<%# bind("SSE_Operator_Feedback")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SSE_Operator_Feedback" runat="server"  Rows="5" Cols="40" Width="97%" TextMode="MultiLine" Text='<%# Bind("SSE_Operator_Feedback") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            

                            <asp:TemplateField HeaderText="Account Holder Company Name" Visible="false">
                                <ItemTemplate>
                                    <asp:Label ID="lblAccountHolderCompanyName" runat="server" Text='<%# bind("AccountHolderCompanyName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="AccountHolderCompanyName" runat="server" Text='<%# Bind("AccountHolderCompanyName") %>'></asp:TextBox>
                                    <input type="button" ID="CopyBotton" runat="server" value="Copy Info" onclick="copybottonclick()"/>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Comments" Visible="false">
                                <EditItemTemplate>
                                    Add Notes<input type="text" id="addcomments" size="75" />
                                    <asp:TextBox ID="Comments" Rows="5" cols="40" Width="97%" runat="server" TextMode="MultiLine"
                                        Text='<%# Bind("Comments") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("Comments") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField ItemStyle-HorizontalAlign="Left" ItemStyle-Font-Bold="true" ItemStyle-ForeColor="Red">
                                <EditItemTemplate>
                                    <asp:Button ID="InsertButton" runat="server" Text="Insert" CommandName="insert">
                                    </asp:Button>
                                    <asp:Button ID="UpdateButton" runat="server" Text="Update"
                                        OnClick="UpdateButton_Click">
                                    </asp:Button>
                                    <asp:Button ID="DeleteButton" runat="server" Text="Delete" CommandName="delete"
                                        OnClientClick="return confirm ( 'Are you sure to delete this record?' )">
                                    </asp:Button>
                                    <asp:Button ID="CancelButton" runat="server" Text="Cancel" CommandName="cancel">
                                    </asp:Button>
                                </EditItemTemplate>
                            <ItemStyle HorizontalAlign="Left" Font-Bold="True" ForeColor="Red"></ItemStyle>
                            </asp:TemplateField>

                        </Fields>

                    <PagerStyle CssClass="pgr"></PagerStyle>
                    </asp:DetailsView>

                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                        SelectCommand="Select * FROM tbluser WHERE userID = @userID" 
                        DeleteCommand="Delete FROM tbluser WHERE userID = @userID"
                        InsertCommand="INSERT INTO tbluser ( 
        FirstName,
        LastName,
        Email,
        CompanyName, 
        CompanyABN,
        Street,
		Suburb,
        StateName, 
        Postcode,  
        Phone,  
        Mobile,     
        CurrentProvider,   
        PromotionCode,
        AdminFee,
        LeadSource,
        TypeOrg, 
        PreferredDay,
        PreferredTime,
        TotalSites,
		ElecMonthQuarter,
		GasMonthQuarter,
        ElecMonthQuarterSpend,
        GasMonthQuarterSpend,
        ElecTotalAnnualSpend,
        GasTotalAnnualSpend,
        TotalAnnualSpend,
        AccountStatus,
        StatusName,
        AccountStatusHistory,
        ProviderID,
        SourceCode,       
        OperatorSSE,
        VendorID,
        DateConverted,
        MoverSwicher,
        RESI_SME,
        ElectricityConversion,
        GasConversion,
        MoveInDate,     
        ID_Type,
        ID_Number,
        ID_Expiry,
        FirstAccountHolderTitle,
        FirstAccountHolderFirstName,
        FirstAccountHolderSurname,
        FirstAccountHolderDOB,      
        SecondAccountHolderTitle,
        SecondAccountHolderFirstName,
        SecondAccountHolderSurname,
        SecondAccountHolderDOB,
        SupplyAddress,
        SupplyAddressSuburb,
        SupplyAddressState,
        SupplyAddressPostcode,
        TenantOwner,
        Elec,
        Gas,
        ProductType,
        NoOfPeopleInHouse,
        ConcessionCardType,
        ConcessionCardEntitlement,
        ConcessionCardNo,
        ConcessionCardExp,
        NameOnConcessionCard,
        NMI,
        MIRN,
        AnyHazards,
        AnyAccessRequirements,
        SpecialInstructionsForAccess,
        AdvisedMainSwitchNeedsTurningOff,
        SafetyCertificateRequired,
        ElecStatus,
        GasStatus,
        Reason,
        ExistingTRUEnergyCustomer,
        AdditionalQuestion,
        SSE_Operator_Feedback
        ) VALUES (
        @FirstName,
        @LastName,
        @Email,
        @CompanyName, 
        @CompanyABN,
        @Street,
		@Suburb,
        @StateName, 
        @Postcode,  
        @Phone,  
        @Mobile,     
        @CurrentProvider,   
        @PromotionCode,
        @AdminFee,
        @LeadSource,
        @TypeOrg, 
        @PreferredDay,
        @PreferredTime,
        @TotalSites,
		@ElecMonthQuarter,
		@GasMonthQuarter,
        @ElecMonthQuarterSpend,
        @GasMonthQuarterSpend,
        @ElecTotalAnnualSpend,
        @GasTotalAnnualSpend,
        @TotalAnnualSpend,
        @AccountStatus,
        @StatusName,
        @AccountStatusHistory,
        @ProviderID,
        @SourceCode,       
        @OperatorSSE,
        @VendorID,
        @DateConverted,
        @MoverSwicher,
        @RESI_SME,
        @ElectricityConversion,
        @GasConversion,
        @MoveInDate,     
        @ID_Type,
        @ID_Number,
        @ID_Expiry,
        @FirstAccountHolderTitle,
        @FirstAccountHolderFirstName,
        @FirstAccountHolderSurname,
        @FirstAccountHolderDOB,      
        @SecondAccountHolderTitle,
        @SecondAccountHolderFirstName,
        @SecondAccountHolderSurname,
        @SecondAccountHolderDOB,
        @SupplyAddress,
        @SupplyAddressSuburb,
        @SupplyAddressState,
        @SupplyAddressPostcode,
        @TenantOwner,
        @Elec,
        @Gas,
        @ProductType,
        @NoOfPeopleInHouse,
        @ConcessionCardType,
        @ConcessionCardEntitlement,
        @ConcessionCardNo,
        @ConcessionCardExp,
        @NameOnConcessionCard,
        @NMI,
        @MIRN,
        @AnyHazards,
        @AnyAccessRequirements,
        @SpecialInstructionsForAccess,
        @AdvisedMainSwitchNeedsTurningOff,
        @SafetyCertificateRequired,
        @ElecStatus,
        @GasStatus,
        @Reason,
        @ExistingTRUEnergyCustomer,
        @AdditionalQuestion,
        @SSE_Operator_Feedback
        )"
        UpdateCommand="UPDATE tbluser SET     
        FirstName = @FirstName,
        LastName = @LastName,
        Email = @Email,
        CompanyName = @CompanyName, 
        CompanyABN = @CompanyABN,
        Street = @Street,
		Suburb = @Suburb,
        StateName = @StateName, 
        Postcode = @Postcode,  
        Phone = @Phone,  
        Mobile = @Mobile,     
        CurrentProvider = @CurrentProvider,   
        PromotionCode = @PromotionCode,
        AdminFee = @AdminFee,  
        LeadSource = @LeadSource,
        TypeOrg = @TypeOrg, 
        PreferredDay=@PreferredDay,
        PreferredTime=@PreferredTime,
        TotalSites=@TotalSites,
		ElecMonthQuarter=@ElecMonthQuarter,
		GasMonthQuarter=@GasMonthQuarter,
        ElecTotalAnnualSpend=@ElecTotalAnnualSpend,
        GasTotalAnnualSpend=@GasTotalAnnualSpend,
        ElecMonthQuarterSpend=@ElecMonthQuarterSpend,
        GasMonthQuarterSpend=@GasMonthQuarterSpend,
        TotalAnnualSpend=@TotalAnnualSpend,
        AccountStatus=@AccountStatus,
        StatusName=@StatusName,
        AccountStatusHistory=@AccountStatusHistory,
        ProviderID=@ProviderID,
        SourceCode=@SourceCode,       
        OperatorSSE=@OperatorSSE,
        VendorID=@VendorID,
        DateConverted=@DateConverted,
        MoverSwicher=@MoverSwicher,
        RESI_SME=@RESI_SME,
        ElectricityConversion=@ElectricityConversion,
        GasConversion=@GasConversion,
        MoveInDate=@MoveInDate,     
        ID_Type=@ID_Type,
        ID_Number=@ID_Number,
        ID_Expiry=@ID_Expiry,
        FirstAccountHolderTitle=@FirstAccountHolderTitle,
        FirstAccountHolderFirstName=@FirstAccountHolderFirstName,
        FirstAccountHolderSurname=@FirstAccountHolderSurname,
        FirstAccountHolderDOB=@FirstAccountHolderDOB,      
        SecondAccountHolderTitle=@SecondAccountHolderTitle,
        SecondAccountHolderFirstName=@SecondAccountHolderFirstName,
        SecondAccountHolderSurname=@SecondAccountHolderSurname,
        SecondAccountHolderDOB=@SecondAccountHolderDOB,
        SupplyAddress=@SupplyAddress,
        SupplyAddressSuburb=@SupplyAddressSuburb,
        SupplyAddressState=@SupplyAddressState,
        SupplyAddressPostcode=@SupplyAddressPostcode,
        TenantOwner=@TenantOwner,
        Elec=@Elec,
        Gas=@Gas,
        ProductType=@ProductType,
        NoOfPeopleInHouse=@NoOfPeopleInHouse,
        ConcessionCardType=@ConcessionCardType,
        ConcessionCardEntitlement=@ConcessionCardEntitlement,
        ConcessionCardNo=@ConcessionCardNo,
        ConcessionCardExp=@ConcessionCardExp,
        NameOnConcessionCard=@NameOnConcessionCard,
        NMI=@NMI,
        MIRN=@MIRN,
        AnyHazards=@AnyHazards,
        AnyAccessRequirements=@AnyAccessRequirements,
        SpecialInstructionsForAccess=@SpecialInstructionsForAccess,
        AdvisedMainSwitchNeedsTurningOff=@AdvisedMainSwitchNeedsTurningOff,
        SafetyCertificateRequired=@SafetyCertificateRequired,
        ElecStatus=@ElecStatus,
        GasStatus=@GasStatus,
        Reason=@Reason,
        ExistingTRUEnergyCustomer=@ExistingTRUEnergyCustomer,
        AdditionalQuestion=@AdditionalQuestion,
        SSE_Operator_Feedback=@SSE_Operator_Feedback
        WHERE userID = @userID">
                        <SelectParameters>
							<asp:ControlParameter ControlID="GridView1" Name="UserID" PropertyName="selectedvalue" /> 
                        </SelectParameters>
                        <DeleteParameters>
                            <asp:Parameter Name="userID" />
                        </DeleteParameters>
                        <UpdateParameters>
                        </UpdateParameters>
                        <InsertParameters>
                        </InsertParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource6" runat="server" 
                    ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                    SelectCommand="Select * FROM tblAccountStatus">
                    </asp:SqlDataSource>

    </form>
</body>

<script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.4.2.min.js" type="text/javascript"></script>

<script src="date.f-0.5.0-min.js" type="text/javascript"></script>

<script src="main.js" type="text/javascript"></script>

</html>

